Model Table JOB

This model represents the human resouces dimension job and is based on the IFS Applications dimension DIM_JOB_DETAILS_JOB.

Attributes

Attribute Description (where applicable)
JobCODE +' - '+ JOB_TITLE as CODE_TITLE.
Job Code TitleConcatenation of job code + '-' + job title
CompanyNatural parent.
Job CodeRefered as Code in dimension.
Job GradeRepresents the job grade
Job TitleRepresents the job title

USED BY MODEL(S)

Model Name
Employee Analysis

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
JOBDIM_JOB_DETAILS_TMDIM_JOB_DETAILS_BIDIM_JOB_DETAILSOn Line